Google Links

Follow the links below to find material targeted to the unit's elements, performance criteria, required skills and knowledge

Elements and Performance Criteria

1. Plan database backup and restore
   • Examine architecture of database file systems and determine likely risk and failure scenarios
   • Determine methods for database backup and restore to mitigate likely risk and failure scenarios
   • Prepare backup maintenance schedules according to organisational backup and restore policy
   • Prepare contingency plans according to organisational backup and restore policy
2. Undertake backup methods appropriate to database requirements
   • Complete full off-line backups with acceptable downtime according to organisational backup and restore policy and procedure
   • Complete online file backups with acceptable downtime according to organisational backup and restore policy and procedure and organisational data security plan
   • Deploy redundant array of inexpensive disks (RAID) configuration aligned with the organisational backup and restore policy
   • Arrange off-site copies of backup files consistent with organisational back and restore procedure and organisational data protection plan
3. Establish and test recovery points and disaster-recovery procedures
   • Determine and document database recovery points based on backup methods, according to organisational backup and restore policy and procedure
   • Test restore process to ensure database can be restored to given recovery points with acceptable down time as specified in organisational backup and restore policy
   • Complete and document restoration of databases to point of failure, without loss of committed transactions
4. Create and deploy a standby database
   • Create and deploy standby databases to support critical organisational functions according to organisational back and restore policy and procedure
   • Prepare documentation for standby databases that meet requirements of organisational backup and restore policy